UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8L+PN1HfoApubBBHpJI0NjJQOxHwf7BT29DEJwq9G8='
WHERE
key_id = 'bcf40d3ccb8a24269b4b47c2ddef51ec2954e8e422b7dfc56d8f47d592c9653a'
AND (
token = 'S8L+PN1HfoApubBBHpJI0NjJQOxHwf7BT29DEJwq9G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)