UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QRlh9opXesnjIabNNERMKs6S9eXdtXKDzu3DO0GiBAw='
WHERE
key_id = '12b3b6e965a0cd6387274d2790ad3576212851063538843f5a7958b1c53eb77b'
AND (
token = 'QRlh9opXesnjIabNNERMKs6S9eXdtXKDzu3DO0GiBAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)