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