UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qMiSGN8c6RSLrIgbpNWn+P3mZUP1HBesoPj+w77juQA='
WHERE
key_id = '2e50f0fb6eda1feceaf382043e3e2cb5756b0ed8070dd495fc9b2ecc9530b2c4'
AND (
token = 'qMiSGN8c6RSLrIgbpNWn+P3mZUP1HBesoPj+w77juQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)