UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VMoJ+emAbeslRt2bc9vf0a3lf9Ph0H/5xvckhnGJX6w=' 
WHERE 
  key_id = '60be7e2d8f6211a05db6e408e4656a239a6ae00ec49e06a4216200c7c48ce148' 
  AND (
    token = 'VMoJ+emAbeslRt2bc9vf0a3lf9Ph0H/5xvckhnGJX6w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023