UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DUHwpV5FstrLdQyJKlYyTIGrukvT0ybRwcfEYqidanw=' 
WHERE 
  key_id = 'abe4bc2973c7ad538d8191a170aba5acffde14af67d0c30ede84edc00a1d7476' 
  AND (
    token = 'DUHwpV5FstrLdQyJKlYyTIGrukvT0ybRwcfEYqidanw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030