UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdPUKyNsw5EaaEAvEeZOyO9NtvsVhcWgoJWiR54ioFo='
WHERE
key_id = '8d18a1a8ace26e2f7a9bec90bcf1e6f76c8250ea3691aed740072ebdfc5e7b2d'
AND (
token = 'mdPUKyNsw5EaaEAvEeZOyO9NtvsVhcWgoJWiR54ioFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)