UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8koJ7q/IlCoakLiSLzDZOVV/z3gsqq9v8sXnWnSzYhE=' 
WHERE 
  key_id = 'ee1ef1aa332f5aab8ab52c542d9b5c0aa4950193a4cec11db17b1093a9fe5a54' 
  AND (
    token = '8koJ7q/IlCoakLiSLzDZOVV/z3gsqq9v8sXnWnSzYhE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022