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