UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8myF7Qb8+NShwWEz6rrbx6ajV50X2B2lLwtlvLja4p8='
WHERE
key_id = 'b3e6f905cd38a6ca7e5d8fd8a0a4bc007537ccec9c645e56766c4e37656c86dc'
AND (
token = '8myF7Qb8+NShwWEz6rrbx6ajV50X2B2lLwtlvLja4p8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)