UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'shQjNvoH2f6+U45KutpY6aUrQv6Azh9WuPGNsbDHEP4='
WHERE
key_id = 'b317aecc649d6cc0311b1a92f0fdb802be4e6407a452f26e1bce9374380d6895'
AND (
token = 'shQjNvoH2f6+U45KutpY6aUrQv6Azh9WuPGNsbDHEP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)