UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/Pxov7H+d+hZlXbXrr735mqcq406PeOofM2GpmaDjuI=' 
WHERE 
  key_id = '33cf26ed678b4a6932b2606e885b0cd85479efa140a34a0a9c5c7d0f206b55d2' 
  AND (
    token = '/Pxov7H+d+hZlXbXrr735mqcq406PeOofM2GpmaDjuI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020