UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xzWMxB+iUlw3VB8Aun/ZG64xqTRmq7s0I+RsVEPLviw='
WHERE
key_id = 'cd0e9716f44e129caa507113c121c8e0d1b64a21a54bbe1f06e79a796f08593c'
AND (
token = 'xzWMxB+iUlw3VB8Aun/ZG64xqTRmq7s0I+RsVEPLviw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)