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