UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hy7dynkxhKr9jLlb1Q0w65Sab2XRMg2MG2iVeREssZ4='
WHERE
key_id = 'c6018684e9c45cc9ba74c7282caae59f0a6e567956261d169ce76062414512d8'
AND (
token = 'Hy7dynkxhKr9jLlb1Q0w65Sab2XRMg2MG2iVeREssZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)