UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wVFwt6fb6sC6B4eZIXllwF0B4TEHkzT7XwWqiOMW+R0='
WHERE
key_id = '4202b4e0c77234278bba09aa71aeae4b9d825fd2d165d976ec755d1d28a8fb46'
AND (
token = 'wVFwt6fb6sC6B4eZIXllwF0B4TEHkzT7XwWqiOMW+R0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)