UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+G6BK3XIHNowvIxAgHWmSoyLTYq4OJ45q0d9kG/FZyU='
WHERE
key_id = '06efd94f9f064ba83b55a565c4dc6775630d108c290bb5f4983e33a77f9e2a20'
AND (
token = '+G6BK3XIHNowvIxAgHWmSoyLTYq4OJ45q0d9kG/FZyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)