UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'befMdzR7OpfKbEf8HCmH7vMyWlNTXjEXSGB+75uLOp4='
WHERE
key_id = 'd48dfe86c9d823da065d42a49286e7d17e3b32ff8e542b78a07ea4b7d04b62c2'
AND (
token = 'befMdzR7OpfKbEf8HCmH7vMyWlNTXjEXSGB+75uLOp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)