UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yxRQSTn8MCTh5NYRlEQBtY1Nwf8RzjCXRLM2E2TFRs4='
WHERE
key_id = 'dc2ab556b7757f1c774ff1b3d824439f9f57bcb3922283ad225edd133c642b70'
AND (
token = 'yxRQSTn8MCTh5NYRlEQBtY1Nwf8RzjCXRLM2E2TFRs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)