UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LkAJcqnbxExJVCBKMryzFc1/GwayLmXqOiLnng7RQdw='
WHERE
key_id = 'ba3e26d238374efb15d56ec5161f0f333eb788b8377cab19f7ae1d1b7fafa1b0'
AND (
token = 'LkAJcqnbxExJVCBKMryzFc1/GwayLmXqOiLnng7RQdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)