UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OyxVWYfyGldFJA5Gmw/9cTWsYgdwCSGQD/cEMrEAvng='
WHERE
key_id = 'a31baf528616c5d66044c85ac0050722a1c5db8cd928eb59d20f2081656ec694'
AND (
token = 'OyxVWYfyGldFJA5Gmw/9cTWsYgdwCSGQD/cEMrEAvng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)