UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QhZcI+P1LSWTPsDBcCbzxFggf5B2RUvADwz0EeUtCkk='
WHERE
key_id = '9a30b9c149c22ce84f37ea10a35ecbf44640a7149755cf5367c6c65fbd37ddf8'
AND (
token = 'QhZcI+P1LSWTPsDBcCbzxFggf5B2RUvADwz0EeUtCkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)