UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4yGUzAtLceJKBU+x2/YtoaPVGfeIUKNjQvNE1pQLQh0='
WHERE
key_id = '4be51649d3c527895c7497b442875fc4bb4d1da09877a16dd481c228ee33322e'
AND (
token = '4yGUzAtLceJKBU+x2/YtoaPVGfeIUKNjQvNE1pQLQh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)