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