UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WtzE0+ANh1NhcLlugYhjZaJuyii+EFIjW1efFIjHIck='
WHERE
key_id = 'e503ba4096cd94ea2a3971988ead0bce56079b41b06f391f7a6df386b6ef5fd4'
AND (
token = 'WtzE0+ANh1NhcLlugYhjZaJuyii+EFIjW1efFIjHIck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)