UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qn6uIUTH8fq1ehHzYgBrg/Hb+f4MzOBODnHuB1OfnBM='
WHERE
key_id = '6c695c68a67505ec8967bb3815828d5513ab98c4321c0ddcb4e1eddc463e6bf4'
AND (
token = 'qn6uIUTH8fq1ehHzYgBrg/Hb+f4MzOBODnHuB1OfnBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)