UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCXXjOmT65Xo8El7zNMHdOdjyP0pt+D+/9n4BtzgcbA='
WHERE
key_id = '6d736e618e2262bff55abdab7f34a834378cc0d64b981e6efff2152735f08487'
AND (
token = 'bCXXjOmT65Xo8El7zNMHdOdjyP0pt+D+/9n4BtzgcbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)