UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rw3LVQewA6vXH4pfdbjEnaO66wkEPXU8HFf+BLnsXvA='
WHERE
key_id = 'c6fcf52943755b8de557a4349faebcc8f7eff1a1cd6e293ce347802d57830911'
AND (
token = 'rw3LVQewA6vXH4pfdbjEnaO66wkEPXU8HFf+BLnsXvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)