UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AyBeEaks0mZ7Z1z2bQ7JZ76j206VqHuV0sObW/wBIeM=' 
WHERE 
  key_id = 'cd7c3749372aff9bfc21e4e01532849cc449fc20472f1a194208c1fbef5f5fb1' 
  AND (
    token = 'AyBeEaks0mZ7Z1z2bQ7JZ76j206VqHuV0sObW/wBIeM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022