UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLRrQL+xYYu38CvwI+pBMPFViPu/el8NC69ikp1acb0='
WHERE
key_id = 'e83889b070fe911ece5733767615914e1009548d65dce3ef906c168d2f6fadf8'
AND (
token = 'ZLRrQL+xYYu38CvwI+pBMPFViPu/el8NC69ikp1acb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)