UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YLlqPBxbYk61lbGDa0EXnc7gSdY1KF42kA1YOTMpmgc='
WHERE
key_id = '88acfdabfa04b6a35867e8be15c47ee2af6c31c6084a5e0fd0d2c877611ff473'
AND (
token = 'YLlqPBxbYk61lbGDa0EXnc7gSdY1KF42kA1YOTMpmgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)