UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nlFY1KxNM7DmHNo3ik/9BS0NyvWr14b2Ii3nxfZAsQM='
WHERE
key_id = '2877f66e2be8fa8091734844e3713cb63889260af189bf24e8f931a04dbe602f'
AND (
token = 'nlFY1KxNM7DmHNo3ik/9BS0NyvWr14b2Ii3nxfZAsQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)