UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K/PI+cq+NzKv0mRr0Vg70lmCgU0eHpO29lUjZuzkGNU='
WHERE
key_id = 'c47d3afbe9939d123bd140a51c8b0b590cb784d19b4a84ea582e509b7460e270'
AND (
token = 'K/PI+cq+NzKv0mRr0Vg70lmCgU0eHpO29lUjZuzkGNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)