UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Ic77HR1VjCfXGBC3I8+BB1rocXpHk+6mq/2WxyxyV0='
WHERE
key_id = '9236a908eca21b997edb2ba228e5388345ce54c2e64429a6205ee2e68e54f7dd'
AND (
token = '4Ic77HR1VjCfXGBC3I8+BB1rocXpHk+6mq/2WxyxyV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)