UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9b8MEGI6bq9heuyQGkw6hAFlWPMUuGcFRwirckRQBI='
WHERE
key_id = 'f6f2bd37c3e16e47f81cfe3beb81e823c51fa612c9682d2bb2d7298a1114e4be'
AND (
token = 'H9b8MEGI6bq9heuyQGkw6hAFlWPMUuGcFRwirckRQBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)