UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '40fZz2YnVsbAHeCtDjWTZpLGFaRtYGPezMBB3YH4BKA='
WHERE
key_id = '7f7b61d165dad639471ec820f0408346c1e7abcbc1e198e6b2826828568b200d'
AND (
token = '40fZz2YnVsbAHeCtDjWTZpLGFaRtYGPezMBB3YH4BKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)